Change the layout of a PivotChart report

Decide whether to make the layout changes on the screen or in the wizard. Usually you can make changes on the screen. If changes result in long delays in retrieving and displaying data, use the wizard.

Click the report.
Display the field buttons if they are hidden: click PivotChart on the PivotTable toolbar and make sure that the Hide PivotChart Field Buttons command is not checked.
Do one or more of the following:

Change the layout on the sheet
1. To move a field from its current position to the series, category, or data area, drag the field button to a new position. For example, to swap the series and categories, drag the series field to the category area, and then drag the previous category field to the series area.
  Fields with icons in the PivotTable Field List window can be used only in the series, category, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
2. To create a page field, drag the field to the page area at the top of the report.
Add or remove a field on the sheet
1. If the PivotTable Field List window is not displayed, click Show Field List on the PivotTable toolbar.
2. Do one or more of the following:
  Add a field Drag the field from the PivotTable Field List window to the area of the report for the type of field you want to create.
  
  Fields with icons in the PivotTable Field List window can be used only in the series, category, and page areas. Fields with icons can be used only in the data area. Fields with icons can be used in any area.
  
  Remove a field Drag the field button out of the report.

Click the associated PivotTable report for the PivotChart report.
On the Data menu, click PivotTable and PivotChart report.
Click Layout.
To rearrange fields, drag them from one area to another in the diagram on the left.
Use the COLUMN area for series fields and the ROW area for category fields.
To add fields, drag them from the list of fields on the right to the diagram.
Some fields can only be used in some of the areas. If you drop a field in an area where it can't be used, the field won't appear in the area.
To remove a field, drag it out of the diagram.
When you're finished changing the layout, click OK, and then click Finish.

Note Changing the layout of a PivotChart report also affects its associated PivotTable report, and some chart formatting may be lost.